﻿IF object_id(N'dbo.UDS_Task', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_Task] (
        [ID]             int          NOT NULL identity(1, 1),
        [ArrangedBy]     nvarchar(50)  COLLATE Chinese_PRC_CI_AS NOT NULL,
        [Subject]        nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [Detail]         nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
        [Address]        nvarchar(300) COLLATE Chinese_PRC_CI_AS NULL,
        [ProjectID]      int          NULL,
        [StartTime]      datetime     NULL,
        [EndTime]        datetime     NULL,
        [Attribute]      bit          NULL,
        [Type]           int          NULL,
        [Status]         bit          NULL,
        [Tag]            int          NULL,
        [CooperatorList] nvarchar(300) COLLATE Chinese_PRC_CI_AS NULL,
        [IsAwake]        bit          NULL,
        [AwakeTime]      datetime     NULL,
        [ContractList]   nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [CreateDate]     datetime     NULL CONSTRAINT [DF_UDS_Task_CreateDate] default((getdate())),

        CONSTRAINT [PK_UDS_Assignment] PRIMARY KEY CLUSTERED ([ID] asc)
    );
END
GO
